use "$root/data/interim/adminassistants_bg.dta", replace

keep if substr(soc,1,2)=="43"

gen month=month(jobdaten)
egen yearmonth=group(year month)
egen ad_id=group(cleantitle employer)
egen ad_czone_id=group(cleantitle employer czone)
egen czone_year=group(czone year)
egen emp_year=group(employer year)
egen czone_yearmonth=group(czone yearmonth)
gen non_tech_skills= skills- count_tech
bysort ad_czone_id: gen non_singleton=_N>1&ad_czone_id!=.
gen wants_at_least_college=educ>=16
gen wants_at_least_hs=educ>=12
drop educ
compress

save "$root/data/cleaned/bg_created", replace

